package com.itheima.mapper;

import com.itheima.domain.Items;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface ItemsMapper {

    //通过orders的id属性找到对应商品信息
    @Select("select i.id,i.name,i.price from orderdetail o,items i where o.items_id=i.id and o.orders_id=#{oid}")
    List<Items> findByOid(Integer oid);
}
